#!/bin/sh

echo Fix test1 ...
echo "UPDATE Games SET Event='Mistrzostwa Płocka - A', Site='Płock', EventDate='2015.06.05', TimeControl='5400';" | sqlite3 -echo -batch games.sqlite
echo
echo Fix test2 ...
echo "UPDATE Games SET Board=substr(Round,3),Round=substr(Round,1,1) WHERE Round LIKE '_.%';" | sqlite3 -echo -batch games.sqlite
# echo "UPDATE Games SET Board=substr(Round,4),Round=substr(Round,1,2) WHERE Round LIKE '__.%';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.06.05' WHERE Round='1' AND Date='2015.??.??';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.06.05' WHERE Round='2' AND Date='2015.??.??';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.06.05' WHERE Round='3' AND Date='2015.??.??';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.06.06' WHERE Round='4' AND Date='2015.??.??';" | sqlite3 -echo -batch games.sqlite
echo
echo Fix test3 ...
# Transforms lines:
# "  1  1101684  PL-2672  GM  Grabarczyk, Mirosław  POL  2438  2600  ŻTMS Baszta Żnin  1971"
# into:
# "GM|Grabarczyk, Miroslaw|POL|2438|2600|ZTMS Baszta Znin|1971"
sed -re y/ĄąĆćĘęŁłŃńÓóŚśŹźŻż/AaCcEeLlNnOoSsZzZz/ -e "s/^  [0-9]+  [0-9]+  PL-[0-9]+  //" -e "s/  /|/g" lista.txt >lista2.txt
./fixtitle.py lista2.txt games.sqlite
echo Done
